/***********************************************************************************************************************************
 *    Name: Restore_History.sql
 *  Author: Frank Figearo — http://www.sqlnerd.me/ — frank@sqlnerd.me
 * Summary: 
**/
SELECT rh.destination_database_name, rh.restore_date, bs.backup_finish_date, bs.type, bmf.physical_device_name
  FROM msdb.dbo.restorehistory rh
	INNER JOIN msdb.dbo.backupset bs ON (rh.backup_set_id = bs.backup_set_id)
	INNER JOIN msdb.dbo.backupmediafamily bmf ON (bs.media_set_id = bmf.media_set_id)
  WHERE rh.destination_database_name = DB_NAME()
  ORDER BY rh.destination_database_name, rh.restore_date;
GO